Many-Dimensional Schema Modeling
نویسندگان
چکیده
Large database schemata can be drastically simplified if techniques of modular and structural modeling are used. Applications and thus schemata have an inner meta-structure. The explicit treatment of the inner structuring may be used during development of large database schemata and may ease the development to a large extent. It is surprising that dimensions and internal separations have not been considered yet also they are very natural and easy to capture. This paper develops an approach to explicit treatment of the inherent many-dimensional structuring on the basis of dimensions such as the kernel dimension, the association dimension, the log dimension, the meta-characterization dimension, and the lifespan dimension.
منابع مشابه
An Analysis of Many-to-Many Relationships Between Fact and Dimension Tables in Dimensional Modeling
Star schema, which maintains one-to-many relationships between dimensions and a fact table, is widely accepted as the most viable data representation for dimensional analysis. Realworld DW schema, however, frequently includes many-to-many relationships between a dimension and a fact table. Having those relationships in a dimensional model causes several difficult issues, such as losing the simp...
متن کاملThe Comparison of Anchor and Star Schema from a Query Performance Perspective
Today's business environment requires that companies have access to highly relevant information in a matter of seconds. Modern Business Intelligence tools rely on data structured mostly in traditional dimensional database schemas, typically represented by star schemas. Dimensional modeling is already recognized as a leading industry standard in the field of data warehousing although several dra...
متن کاملEvent-Entity-Relationship Modeling In Data Warehouse Environments1
We use the event-entity-relationship model (EVER) to illustrate the use of entity-based modeling languages for conceptual schema design in data warehouse environments. EVER is a general-purpose information modeling language that supports the specification of both general schema structures and multi-dimensional schemes that are customized to serve specific information needs. EVER is based on an ...
متن کاملSCIT: A Schema Change Interpretation Tool for Dynamic-Schema Data Warehouses
Data Warehouses (DW) have to continuously adapt to evolving business requirements, which implies structure modification (schema changes) and data migration requirements in the system design. However, it is challenging for designers to control the performance and cost overhead of different schema change implementations. In this paper, we demonstrate SCIT, a tool for DW designers to test and impl...
متن کاملA Three-dimensional Numerical Modeling of Contaminant Dispersion from Arvand Rood River into the Persian Gulf
The Persian Gulf is an important economic and geo-political region. Owing to its oil and gas resources, it is one of the busiest waterways in the world. There are many operating oil wells in the northern part of the Persian Gulf . As a result, the risk of contaminant dispersion is high. The deliberate discharge of 6.3 million barrels of crude oil during the 1991 war against Kuwait in this regio...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2002